package org.bulu.project.system.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.bulu.project.system.model.entity.Category;

import java.util.List;

@Mapper
public interface CategoryMapper {
    /*
        获取所有分区
     */
    @Select("select * from category")
    List<Category> getAllCategory();

    /*
        根据分区id查询分区信息
        @param mcId 主分区
        @param scId 子分区
     */
    @Select("select * from category where mc_id = #{mcId} and sc_id = #{scId}")
    Category getCategoryById(Integer mcId,Integer scId);
}
